|
JCapper Message Board JCapper 101
|
| Home |
Register
Log In |
| By | Question... | |
| Caveat 1/6/2016 2:19:05 PM | I feel a little stupid asking this after 3 years but... In SQL Mode can I use a factor thats not showing on the HTML Report as a UPR factor... or does it need to be one of the 35 mike take for example qrating ~Edited by: Caveat on: 1/6/2016 at: 2:19:05 PM~
| |
| JackB 1/6/2016 8:38:33 PM | I have Qrating in the list of 48 factors. You can move it into those. Or make it a UserFactor and use it in the 35 factors that make up Fxx. Be careful moving stuff around, You might have a UDM pulling that cell, thinking it is some other factor. Jeff correct me if I'm wrong. ~Edited by: JackB on: 1/6/2016 at: 8:38:33 PM~
| |
| Caveat 1/7/2016 7:50:02 AM | Thanks Jack....I fixed that Now another... Suppose I'm hand crafting a UPR .. and I want to use a factor( say willtowin) and its not one of the 35 or showing up on the HTML report... Can I use it in my UPR ? mike ~Edited by: Caveat on: 1/7/2016 at: 7:50:02 AM~
| |
| jeff 1/7/2016 8:42:59 AM | --quote: "In SQL Mode can I use a factor thats not showing on the HTML Report as a UPR factor...--end quote The short answer? Yes. The longer answer? Here's how it works: When creating entries in the IV Table Wizard or UPR Tools to define UserFactors and/or UPR: Your sql factor setup and your html report layout do not come into play at all. Simply put: Any factor displayed in the factors drop downs of the IV Table Wizard or UPR Tools interfaces can be used in your entries to define UserFactors and/or UPR. Q. So when does the sql factor setup come into play? A. The sql factor setup comes into play for sql udms. More specifically: The sql expressions that make up your sql udm definitions are limited to the field names in the starterhistory table as defined in the table schema doc here: http://www.jcapper.com/helpdocs/starterhistorytableschema.html Q. When does the html report layout come into play - and what does it do? A. The html report layout controls the location and display attributes of the factors shown on your html report. As such it has nothing to do whatsoever with UserFactors, UPR, and/or SQL UDMs. -jp .
| |
| jeff 1/7/2016 8:43:55 AM | --quote: "Now another...--end quote Yes. (See above.) -jp .
| |
| Caveat 1/7/2016 11:11:45 AM | :) thxs
|
| Reply |
|
Copyright © 2018 JCapper Software back to the JCapper Message Board www.JCapper.com |